package manager.point;


import common.db.*;
import common.main.*;
import java.util.*;

public class PointListBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String sort = (String)inputTable.get("sort");
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT ID, POINT_VALUE, EXPERATION_DATE,TO_CHAR(POINT_START_DATE, 'YYYY-MM-DD') POINT_START_DATE, USEYN FROM POINT ");	
		queryBuffer.append("ORDER BY " + sort);
		
		DBExecute dbe = new DBExecute(queryBuffer.toString());	
		outputList = dbe.getDataList();

	}
}
